Logs_Haynes_ProcessRepairTasksV3 Tables

The logs_haynes_processRepairTasksV3_latest and logs_haynes_processRepairTasksV3_changelog tables stores the requests and responses of each processRepairTasksV3 haynes pro API call made, including errors and api timestamps.

---

🔹 Standard Columns

Column Name	Data Type	Nullable	Description
document_name	STRING	YES	Name of the Firestore document
document_event_id	STRING	YES	Unique ID representing the document event (change ID)
document_timestamp	TIMESTAMP	YES	Timestamp when the document event occurred
document_operation	STRING	YES	Type of Firestore operation (e.g., CREATE, UPDATE, DELETE)
document_id	STRING	YES	ID of the Firestore document
apiCallTimeInMilliSeconds	INT64	YES	Time taken to complete the API call in milliseconds
context	STRING	YES	Context of the log (e.g., module or feature name)
level	STRING	YES	Log level
year	STRING	YES	year of the API call
month	STRING	YES	month of the API call
day	STRING	YES	day of the API call
documentId	STRING	YES	unique document id in firebase

---

🔸 Struct Columns

request

Column Name	Data Type	Nullable	Description
message	STRING	YES	Description of the request
payload.countryCode	STRING	YES	Country code
payload.sessionTokenRequestKey	STRING	YES	Session Token Request Key
payload.countryCode	STRING	YES	Country code (e.g., 'US', 'DE')
payload.identifierValue	STRING	YES	Identifier value used for the lookup
payload.languageCode	STRING	YES	Language code (e.g., 'en', 'de')
payload.lookupType	STRING	YES	Type of lookup being performed
payload.repairTaskIds	STRING	REPEATED	List of repair task IDs
payload.repairtimeTypeId	INTEGER	YES	ID representing the type of repair time
payload.useMaintenanceTasks	BOOLEAN	YES	Indicates if maintenance tasks should be used
payload.vehicleType	STRING	YES	Type of vehicle (e.g., 'Car', 'Truck')

| timestamp | INT64 | YES | Timestamp of the request (in Unix time) |

response

Column Name	Data Type	Nullable	Description
message	STRING	YES	Response message
timestamp	INT64	YES	Timestamp of the response (in Unix time)
data.ProcessRepairTasksV3Result	RECORD	YES	Contains processed repair task results
data.ProcessRepairTasksV3Result.TechnicalData	RECORD	YES	Technical data related to repair tasks
data.ProcessRepairTasksV3Result.TechnicalData.basketItems	RECORD REPEATED	YES	List of repair task basket items
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item	RECORD REPEATED	YES	Individual item within basket
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item.calculatedTime	INTEGER	YES	Time calculated for the task
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item.description	STRING	YES	Description of the item
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item.genarts	RECORD	YES	Genarts data
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item.genarts.item	RECORD REPEATED	YES	List of genarts items
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item.genarts.item.description	STRING	YES	Description of genarts item
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item.genarts.item.id	INTEGER	YES	ID of the genarts item
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item.genarts.item.mandatory	BOOLEAN	YES	Indicates if the item is mandatory
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item.id	STRING	YES	Identifier of the item
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item.jobType	STRING	YES	Type of job
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item.priceWithoutVat	STRING	YES	Price excluding VAT
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item.repairitemsInfo	RECORD	YES	Info about repair items
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item.repairitemsInfo.includedList	RECORD	YES	Included list of repair items
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item.repairitemsInfo.includedList.item	RECORD REPEATED	YES	Included repair item
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item.repairitemsInfo.includedList.item.awNumber	STRING	YES	Assembly work number
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item.repairitemsInfo.includedList.item.description	STRING	YES	Description of included repair item
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item.repairitemsInfo.includedList.item.direction	STRING	YES	Direction of repair
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item.repairitemsInfo.includedList.item.hasInfoGroups	BOOLEAN	YES	Indicates if info groups are present
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item.repairitemsInfo.includedList.item.jobType	STRING	YES	Job type of included item
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item.repairitemsInfo.includedList.item.value	INTEGER	YES	Value associated with the item
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item.nodeId	STRING	YES	Node identifier
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item.subtotal	STRING	YES	Subtotal amount
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item.vat	STRING	YES	VAT amount
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item.repairPriceWithoutVat	STRING	YES	Repair price excluding VAT
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item.repairTasksVat	STRING	YES	VAT on repair tasks
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item.status	RECORD	YES	Status info for the repair task
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item.status.statusCode	INTEGER	YES	Status code
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item.totalRepairPrice	STRING	YES	Total repair price
data.ProcessRepairTasksV3Result.TechnicalData.basketItems.item.totalRepairTime	INTEGER	YES	Total time required for repair

timestamp

Column Name	Data Type	Nullable	Description
seconds	INT64	YES	Seconds since Unix epoch
nanoseconds	INT64	YES	Nanoseconds part of the timestamp

error

Column Name	Data Type	Nullable	Description
data	STRING	YES	Additional error data
message	STRING	YES	Error message
name	STRING	YES	Name/type of the error
stack	STRING	YES	Stack trace of the error
timestamp	TIMESTAMP	YES	Timestamp when the error occurred

---